Programming with Python

Graded Project - 2

Marketing Data Analysis

1

Loading Market Dataset

Displaying 5 random samples

Getting Info about Data

Views

2

Statistics of dataset

Varaiance of dataset

50% of data lies at

Lower quarter of the data

Midddle of the data

Upper quarter of the data

3

Finding Missing Values

Only Income has 24 missing values

Views

4

Removing extra special characters

Imputing null values with the median value of the Income Column (Relate to 3 Question)

Converting Dt_Customer datatype

5

Finding Age of the Customers

Statistical summery of the Age

Views

6

Analysing the expenditure of customers on various products

Finding how much percentage of money spent on various products by each customer

Finding how much percentage of money spent on each products by all customers

Views

7

Analysing the different purchasing mediums

Total amount of purchases done by customers through different mediums

Finding contribution of each channel to the total purchases

Views

8

Analysing Compaigns

For finding sucessful campaigns we need to sum the peoples who like the offers in particular campaigns

Views

9

Analysing revenue generated by various products

Views

10

Analysing Age and Response of customer in last campaign

Age Vs Who Accept offer

Views

Views

Views

11

Analysing Response with the country

Views

12

Analysing relation between Dependents and total amount spent and total purchases

Dependents = Kidhome + Teenhome

Views

Finding total purchases with respect to dependents

Views

13

Correlation analysis

We display correlation analysis visually using Heatmap

Views

14

Analysing complains with respect to Educational background

Views

15

Pair plot to analyse different data sets

Views